﻿CREATE TABLE [dbo].[WindowsEventEntry] (
    [WindowsEventEntryRowId]  INT           IDENTITY (1, 1) NOT NULL,
    [RoleRowId]               INT           NOT NULL,
    [WindowsEventLogRowId]    INT           NOT NULL,
    [WindowsEventSourceRowId] INT           NOT NULL,
    [DateTimeUTC]             DATETIME      NOT NULL,
    [EventNumber]             SMALLDATETIME NOT NULL,
    [InstanceNumber]          SMALLINT      NOT NULL,
    [EventLevel]              SMALLINT      NOT NULL,
    [Description]             VARCHAR (MAX) NOT NULL,
    CONSTRAINT [PK_WindowsEventEntry] PRIMARY KEY CLUSTERED ([WindowsEventEntryRowId] ASC)
);

